4D Analytics

Dynamic Advanced Charts Family of Widgets

Last updated: July 10, 2020

The Dynamic Advanced chart widget sizes are: 2 x 1, 2 x 2, 3 x 1, 3 x 2, 4 x 2, 4 x4

The configuration options available from within the Dynamic Advanced Chart widget are described here. If you are using the Dynamic Overlay Chart, Dynamic Utility Vs Temperature or Dynamic Stacked Chart widgets then these are subsets of the Dynamic Advanced Chart widget and not all configuration options will be available.

There is the Dynamic Advanced Point Overlay widget, which is a subset of the Dynamic Advanced Chart, but with the inclusion of Series 2 and Series 3 configuration.

There is the Dynamic Live Data Chart, which displays live data as it comes in without having to refresh the whole widget. It is also a subset of the Dynamic Advanced Chart, but with a couple of extra configuration items.

The advantages of using the Dynamic Advanced Chart widget is that many options are available and it is easy to move between overlay and stacked or to show future data. However, if your intent is to create only a specific overlay, utility vs temperature or stacked bar chart then using those widgets hides the more advanced configuration.

It's possible that industry specific widgets will also be subsets of the Dynamic Advanced Chart widget.

The charts can handle up to 30,000 points. Anything more than this and a Too much data to show message is displayed.

The live widget has an “Export to CSV” icon, allowing the chart data to be exported. This feature is available for all Dynamic widgets, except for "Dynamic Gauge" and "Dynamic Live Data Chart".

Customisation

Widget Configuration - The following configuration affects the whole widget.

Value Default Comment
Widget Heading Dynamic Advanced Charts Enter the name of the widget as it is to appear in the heading.
Legend Layout Horizontal Alignment of the legend is Horizontal or Vertical.
Legend Position Top-Centre The legend can be aligned in various positions according to the options in the drop-down.
Summary Type RAW Shows either raw or aggregated data. This can be Hourly, Daily, Monthly, Yearly or Raw (default). The option of Drilldown on Periods means that the widget will adhere to the month displayed on the dashboard, which may be current month or previous month or any month that the user selects - the widget will then cycle through the periods, e.g., if monthly then clicking on a day will show all the daily data. Clicking on an hourly value will loop back to a yearly view. The option Aggregated Value returns one value per series/row of all the data values within the chosen Period Selection aggregated by the configured Line Summary.
Period Selection Dashboard/Period Selector If the user chooses Dashboard/Period Selector then the date range of the chart will vary, according to the dashboard or report, i.e. either the date picker on the dashboard or the date picker on the report. If the user chooses Last N Values then the chart will always show the last N values, as configured in the "No. Of Values" field. The default is 14. If the user chooses Historical/Future Days then the chart will show days before and after the current day, as configured in the "Historical Days" and "Future Days" fields. The defaults are 5 and 2 respectively.
Historical Days 5 Configure the number of days to show prior to the current day. Only used if the "Period Selection" of Historical/Future Days is used.
Future Days 2 Configure the number of days to show after the current day. Only used if the "Period Selection" of Historical/Future Days is used. Note: The current day counts as 1, so a value of 3 for example would show data from today (current day), tomorrow and the day after.
No. of Values 14 If "Period Selection" is set to Last N Values then this configuration is used. Specify the number of values to display on the chart.
Drilldown (from chart or icon) Engineering Charts Choose between a drilldown to Engineering Chart, a drilldown to a dashboard, a drilldown to a report, or no drilldown at all.
Note: The icon is only displayed when the "Summary Period" is set to Drilldown on Periods. With this setting, clicking the charts drills down to a yearly/monthly/daily period, so it is not possible to initiate the engineering chart from the chart. In this instance, the icon is used to enable access to the engineering chart.
Dashboard List blank A list of all the dashboards the user has access to.
Reports List blank A list of all the reports the user has access to.
Drilldown Target popup Choose between a drilldown in a new Popup or a drilldown in a New Window.
X Axis Date Format Default Specify the date format for the X-Axis. DateFormat
X Axis Label Font Size, Rotation Chart Default Change the X-axis font size and rotation if required. The syntax is pixel size, degrees - for example, 10px,315
Show Today Zone Hide Hide the zone, or show a vertical bar as a marker for today's Zone, and included a label Zone & Label.
Today Zone Colour 0 Set the colour for the today zone. See Line Colour section for options.
Stacking Style None None - No stacking will occur, series will be shown side by side. Normal - Stacking will be one series on top of the other. Percent - The height of the stacking will be full height and the series will be apportioned according to a percentage of 100%.
Y-Axis Labels Enter a comma delimited list of labels to use on the y-axes. An empty string indicates use the default label. For example: My Label1,,Third Label - Will override the first 3 y-axis labels with the first one being My Label1, the second one will be the default label, and the third one will be Third Label. Note : The units from the y-axis label will hide when the widget config Y-Axis Label (Title) is configured the same as the units for the y-axis.
Y-Axis Behaviour Viewport Scaling Chart Default - The y-axis scale will adjust to fit the max and min values within and just outside (the date range) of the current viewport. Viewport Scaling - Scale each y-axis to the data shown in the viewport (+/- 5%). Single Y-Axis - Put all points regardless of units on single catch all y-axis (will also apply Viewport Scaling on this option). Manual Scaling - Allow user to specify scales.
Y-Axis Scaling [min]to[max],[min]to[max]... Only applicable of "Y-Axis Behaviour" is set to Manual Scaling. User keys the scales for each axis: e.g., 0to100,-30to60,[min]to100,0to[max] In the above example: First y-axis is configured to show 0 to 100. Second y-axis to show -30 to 60. Third y-axis to show minimum data value to 100. Fourth y-axis to show 0 to maximum data value.
Y-Axis Tick Amount Chart Default Number of ticks each y-axis should show. Blank for chart default.
Refresh Period No Refresh Select a refresh period from the drop-down menu from between 15 seconds to 1 hour, or No Refresh at all.
Show Alarm Levels None Select which (if any) alarms levels to show on the chart. None, All Alarms, High & Low Faults (both High Fault and Low Fault), High & Low Alerts (both High Alert and Low Alert), or individual alarm levels. If alarm levels are shown, then for which row is specified by the "Alarm" column radio button within "Row Configuration". Alarm levels can only be shown for a single row at a time. Note 1: Alarm levels are only shown when "Show Alarms Levels" is set to anything other than None, and the alarms are enabled on the point for the alarms levels chosen to show. Note 2: When the trace is showing more than one point (i.e. is aggregated) the alarms levels will not be shown. Note 3: When the aggregation method is COUNT, and the row is selected as the alarm level, the alarms levels will not be shown (whether aggregated or not). Note 4: If the "Summary Type" is not Raw data (all other options can aggregate data), alarm levels are not shown. Note 5: If the "Stacking Style" is Normal or Percent, alarm levels are not shown. Note 6: If the row/series selected as the alarm level is hidden (by clicking the legend), the associated alarms levels will also be hidden.
3D Chart (Columns Only) No Yes to display columns in 3D, No for 2D (default).
Show Vertical Grid False True - A vertical grid is displayed within the chart. False - A vertical grid is not displayed within the chart.
Set Alarm Labels (e.g., min::::max) LowFault:LowAlert:HighAlert:HighAlarm:HighFault Enter the name of the alarm labels as they are to appear in the chart.
Show Logarithmic Scale Option No Switches left and/or right y-axes to logarithmic scaling. This is used when there is a large range of values.
Show Historical Zone No Displays a shaded area on the chart from the beginning of the x-axis to the date/time right now.
Historical Zone Colour Tan Sets the colour of the shaded historical zone.

Row Configuration

The following configuration is done on an individual row basis. Each row can be set independently of another.

The order of each row is commonly called the ZOrder. If you configure a series 1 then it is at the bottom of the ZOrder. A series on the second row will appear on top of a series on the 1st row. If you need, for example, a line chart to be on top of a bar chart then configure your bar chart on line 1 and your line chart on line 2.

Value Default Comment
Label [PointName] If left blank, and there is more than one point configured per row, then only the first point name is chosen. A label can be used to override the point name. $parent and $grandparent can be used to display the parent or the grandparent container name of a point, instead of the point name.
Type Line Line types have the following options. Each row can be configured independently of the others:
  • Line – The chart displays a series of datapoints connected with a straight line.
  • Column – The chart displays a series of datapoints as vertical bars.
  • Area – The area chart functions the same way as a line chart only it fills the areas between the line and 0.
  • Scatter – The chart displays a series of datapoints as single points without connecting them.
  • Spline – The chart displays a series of datapoints connected with a curved line.
  • Area Spline – The Area Spline chart is the same as area, only the line is a spline instead of straight lines.
Line Colour Default If no colours are chosen by the user then they default to a standard palette of colours. This palette is configured within Web Config under the "Dynamic Chart Theme" setting. Colours can be described in several ways: The standard way is for a colour to be described in a hexadecimal format, e.g., #00FF00. Colours can additionally be described in an RGB format, e.g., rgb(0,255,0). Any colour that is entered as invalid will be displayed as black. When exporting a chart to PDF, only a limited set of named colours are supported. Black (#000000) Silver (#C0C0C0) Gray (#808080) White (#FFFFFF) Maroon (#800000) Red (#FF0000) Purple (#800080) Fuchsia (#FF00FF) Green (#008000) Lime (#00FF00) Olive (#808000) Yellow (#FFFF00) Navy (#000080) Blue (#0000FF) Teal (#008080) Aqua (#00FFFF) Other named colours are cannot be used (such as orange and pink). To use other colours the hex code should be used (#FFA500 for orange and #FFC0CB for pink).
Line Marker Chart Default Line Markers can be used when the line "Type" is Line, Area or Scatter. A number or markers are available, including the option for no marker. Note: A scatter with no marker would be blank.
Line Style (Historical) Solid Set the line style for data prior to the current day. Only applicable when "Type" is set to Line or Area.
Line Style (Future) Solid Set the line style for data after (and including) the current day. Only applicable when "Type" is set to Line or Area.
Line Summary (Aggregation) AVG If "Summary Type" is Raw then all options other than COUNT are ignored; otherwise the data will be aggregated as AVG, MAX, MIN, SUM, COUNT.
Number Format 0.## The number format can be written as a mask: 0 (Digit) # (Digit, zero shows as absent) . (The position of the decimal point Example: ###.##) , (The group separator for thousands. Example: ###,###.##) % (Displays the number as a percentage. Example: ##%) ; (Pattern separator. The first pattern will be used for positive numbers and the second for negative numbers)
Selected ON Whether the series is initially selected or not. If the series is hidden, it will be shown as disabled in the legend, and can be re-enabled (un-hidden) by clicking the series label on the legend.
Data Shown Both If historical and future data is being viewed then this option can display both or suppress either historical or future.
Show Logbook No If Logbook entries are stored against the underlying data then they can be shown.
Stack 1 If the "Stacking Style" field is set to Normal or Percent, then stacks can be chosen, from 1 to 4. The series will appear in the stack number specified, so different series' can appear in different stacks, or all be set to the same stack.
Date Offset None

A common scenario is to configure a series displaying the current period's data and for comparison (perhaps as a target), offset last period's data on another series. The user can describe both the periods and the offset value.

  • yy signifies years
  • mm signifies months
  • dd signifies days
  • Negative symbol for previous periods
  • Positive symbol for future periods
    • Eg., mm-2 for 2 months ago (previous)

Example:

With a “Date Offset” of yy+1. Current year is 2018. The chart shows that March 2017’s data has been offset to display as March 2018.

The same point has been configured for both rows in the chart, just for one of the rows there is an offset configured.

Alarm If "Show Alarm Levels" is configured to show alarms, then the series (row) with the "Alarm" radio button checked, is the series whose alarms will be displayed in the chart. Only one row at a time can have this button checked.
Display All Org Sites False True - Ignore the treeview selection, the chart always shows all data. False - Does not ignore the treeview selection, the chart shows all data from the selected site.

POINTn

Enter the PointID(s) to appear on the chart.

The following configuration appears only in the Dynamic Advanced Point Overlay widget.

Summary (Aggregation) AVG Same as "Line Summary (Aggregation)" - see above. Series 1 is columns only in this widget.
Series 2 Label Series 3 Label Point Name If left blank, and there is more than one point configured per row, then only the first point name is chosen. A label can be used to override the point name.
Series 2 Type Series 3 Type Line The type of series can be Line, Column or Scatter.
Series 2 Colour Series 3 Colour Chart Default If no colours are chosen by the user then they default to a standard set of colours. See "Line Colour" configuration above for details of colour configuration.
Series 2 Marker Series 3 Marker Chart Default Line Markers can be used when the line "Type" is Line, Area or Scatter. A number or markers are available, including the option for no marker. Note: A scatter with no marker would be blank.
Series 2 Line Style Series 3 Line Style Solid Set the line style for the plots. Only applicable when "Type" is set to Line.

POINTSERIES2_n

Enter the PointID(s) to appear on the chart as Series 2.

POINTSERIES3_n

Enter the PointID(s) to appear on the chart as Series 3.